|
100
|
How can I programmatically clear the control's filter
// Click event - Occurs when the user presses and then releases the left mouse button over the control.
void __fastcall TForm1::Pivot1Click(TObject *Sender)
{
Pivot1->ClearFilter();
}
Pivot1->BeginUpdate();
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->FilterBarPromptVisible = Expivotlib_tlb::FilterBarVisibleEnum::exFilterBarPromptVisible;
Pivot1->FilterBarPromptPattern = L"USA";
Pivot1->EndUpdate();
|
|
99
|
Is it possible to prevent closing the control's filter bar, so it is always shown (prompt-combined)
Pivot1->BeginUpdate();
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->FilterBarPromptPattern = L"USA";
Pivot1->FilterBarPromptVisible = Expivotlib_tlb::FilterBarVisibleEnum::exFilterBarVisible | Expivotlib_tlb::FilterBarVisibleEnum::exFilterBarPromptVisible;
Pivot1->EndUpdate();
|
|
98
|
Is it possible to prevent closing the control's filter bar, so it is always shown (prompt)
Pivot1->BeginUpdate();
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->FilterBarPromptVisible = Expivotlib_tlb::FilterBarVisibleEnum::exFilterBarPromptVisible;
Pivot1->FilterBarPromptPattern = L"USA";
Pivot1->EndUpdate();
|
|
97
|
Is it possible to prevent closing the control's filter bar, so it is always shown
Pivot1->BeginUpdate();
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->FilterBarCaption = L"len(value) = 0 ? `<fgcolor=808080>no filter` : value";
Pivot1->FilterBarPromptVisible = Expivotlib_tlb::FilterBarVisibleEnum::exFilterBarVisible;
Pivot1->EndUpdate();
|
|
96
|
How can I find if the control is running in DPI mode
OutputDebugString( PChar(Pivot1->FormatABC(L"dpi = 1 ? `normal/stretch mode` : `dpi mode`",TNoParam(),TNoParam(),TNoParam())) );
|
|
95
|
If I connect it to a datasource, all works perfectly but the records that I see in the control is a little number of total of the recordset. I need to show all 60.000 rows of the recordset without click on the [...] button. It s possible to setting up this parameters
Pivot1->DisplayPivotData = -1;
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
|
|
94
|
How do I change the drop down filter icon/button (white)
Pivot1->BeginUpdate();
Expivotlib_tlb::IAppearancePtr var_Appearance = Pivot1->VisualAppearance;
var_Appearance->Add(2,TVariant(String("gBFLBCJwBAEHhEJAAEhABX8GACAADACAxSDEMQBQKAAzQFAYbhgHCGAAGQaBUgmFgAQhFcZQSKUOQTDKNYykCIRSDUJYkSZEIyjBI8ExXFqNACkGKwYgmNYiTLAcgAN") +
"J0WBaGIZJ4gOT5fDKMoEDRRYADFCscwxJybQAqGQKKb+VgAVY/cTyBIAEQSKA0TDOQ5TSKWB4JPZQRBEbZMNBtBIUJquKaqShdQJCU5FdY3Xblez9P7AMBwLFEC4NQ8Y" +
"NYuPhjR4dRTIMhvVAsUArFh8Zg9GZZFjmDIDT4ydBLTQwcyVIKnP5qOa6XbmPoCQDYKxZHYxPzVDa3axuL76dqCAT7XrXNy1TbNRrzQKfcJqfCbdw2YaDZLOOT3fjuI4" +
"hhKaRzFAHJ+jYQ4xHuY4gHuGIXGeExqC8Tp6C+PoEm+G5ImycRgh0XwvDGa5rgOeoejyXwnFeQp2mkf5ClgBB9gCWIYAwfYAEKV58mkdwOggNArgOXY2EWLoDkKOA0mg" +
"bhOGgZApgaSBIHWSYHSmbApgYThmESZYJkIeIkgeCpfliLIHgpMIcmUYYYmODAlg2SI4mWfRfGOEguDcCRjFYAJihCQhJBSDoRmONgKEcI4kFCEJhhOVYTmYnAlEAQhW" +
"BMJYJGYWoWmWSR2F6F5lnkWAQhUAgpEieRWEuSYkjWGpmkmNhuhuZwJkYcocmaaYkjyEhngnUA6lEFAlAEgI="));
var_Appearance->Add(1,TVariant("CP:2 -6 -4 2 4"));
Pivot1->Background[Expivotlib_tlb::BackgroundPartEnum::exHeaderFilterBarButton] = 0x1000000;
Pivot1->Background[Expivotlib_tlb::BackgroundPartEnum::exCursorHoverColumn] = Pivot1->BackColor;
Pivot1->HeaderVisible = true;
Pivot1->HeaderHeight = 24;
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->DisplayFilterList = Expivotlib_tlb::FilterListEnum::exShowCheckBox | Expivotlib_tlb::FilterListEnum::exSortItemsAsc;
Pivot1->PivotBarVisible = Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarVisible;
Pivot1->EndUpdate();
|
|
93
|
How do I change the drop down filter icon/button (black)
Pivot1->BeginUpdate();
Expivotlib_tlb::IAppearancePtr var_Appearance = Pivot1->VisualAppearance;
var_Appearance->Add(1,TVariant(String("gBFLBCJwBAEHhEJAAEhABXUIQAAYAQGKIcBiAKBQAGYBIJDEMgzDDAUBjKKocQTC4AIQjCK4JDKHYJRpHEZyCA8EhqGASRAFUQBYiWE4oSpLABQaK0ZwIGyRIrkGQgQ") +
"gmPYDSDNU4zVIEEglBI0TDNczhNDENgtGYaJqHIYpZBcM40TKkEZoSIITZcRrOEBiRL1S0RBhGcRUHZlWzdN64LhuK47UrWdD/XhdVzXRbjfz1Oq+bxve48Br7A5yYTh" +
"dr4LhOFQ3RjIL4xbIcUwGe6VZhjOLZXjmO49T69HTtOCYBEBA"));
Pivot1->Background[Expivotlib_tlb::BackgroundPartEnum::exHeaderFilterBarButton] = 0x1000000;
Pivot1->Background[Expivotlib_tlb::BackgroundPartEnum::exCursorHoverColumn] = -1;
Pivot1->BackColorHeader = RGB(0,0,0);
Pivot1->ForeColorHeader = RGB(255,255,255);
Pivot1->HeaderVisible = true;
Pivot1->HeaderHeight = 22;
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->DisplayFilterList = Expivotlib_tlb::FilterListEnum::exShowCheckBox | Expivotlib_tlb::FilterListEnum::exSortItemsAsc;
Pivot1->EndUpdate();
|
|
92
|
How do I prevent showing the control's BackColorAlternate property on empty / non-items part of the control
Pivot1->BeginUpdate();
Pivot1->BackColorAlternate = 0x7ff0f0f0;
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"12";
Pivot1->PivotColumns = L"sum(5)";
Pivot1->EndUpdate();
|
|
91
|
How can I find out if the user clicks the grid's header
// MouseMove event - Occurs when the user moves the mouse.
void __fastcall TForm1::Pivot1MouseMove(TObject *Sender,short Button,short Shift,int X,int Y)
{
OutputDebugString( L"Type of ColumnFromPoint: " );
OutputDebugString( PChar(Pivot1->ColumnFromPoint[-1,-1]) );
OutputDebugString( L" should not be VT_NULL" );
OutputDebugString( L"Type of ValueFromPoint: " );
OutputDebugString( PChar(Pivot1->ValueFromPoint[-1,-1]) );
OutputDebugString( L" should be VT_NULL" );
}
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)";
|
|
90
|
What should I set FormatPivotHeader to, to show it on the columns header only
Pivot1->BeginUpdate();
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)/12";
Pivot1->FormatPivotHeader = TVariant(String("(iaggregate ? ( caption + ` <off -6><font ;6>(` + lower(caggregate) + ')</off></font>') : caption) + ( ( display=1 ? `<c>Date: ") +
"<b><upline><dotline>` + date(`now`) : `` ) + `</dotline> </b>` )");
Pivot1->EndUpdate();
|
|
89
|
What should I set FormatPivotHeader to, to show "Report Generated on 7/9/2016 14:20" etc when the report is executed (ie the date and time will change)
Pivot1->BeginUpdate();
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)/12";
Pivot1->FormatPivotHeader = TVariant(String("(iaggregate ? (`<b>` + caption + `</b> <off -6><font ;6>(` + lower(caggregate) + ')</off></font>') : caption) + `<r>ReportDate:") +
" ` + date(`now`)");
Pivot1->EndUpdate();
|
|
88
|
Is it possible to display aggregate result on parent rows as well
Pivot1->BeginUpdate();
Pivot1->HeaderHeight = 22;
Pivot1->DefaultItemHeight = 20;
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"12[bold],0";
Expivotlib_tlb::IFormatConditionalAppearancePtr var_FormatConditionalAppearance = Pivot1->FormatConditionalAppearances->Add(L"nempty",TVariant("not empty"),TVariant(""));
var_FormatConditionalAppearance->Expression = L"len(value) != 0";
var_FormatConditionalAppearance->BackColor = RGB(240,240,240);
Pivot1->PivotColumns = L"sum(5)[nempty]/6";
Pivot1->IncludeExpandColumn = Expivotlib_tlb::IncludeExpandColumnEnum::exIncludeExpandColumn;
Pivot1->DrawGridLines = Expivotlib_tlb::GridLinesEnum::exNoLines;
Pivot1->ShowBranchRows = Expivotlib_tlb::ShowBranchRowsEnum::exBranchIncludeAggregate | Expivotlib_tlb::ShowBranchRowsEnum::exBranchTree;
Pivot1->EndUpdate();
|
|
87
|
How do I show expanded/collapsed rows
Pivot1->BeginUpdate();
Pivot1->HeaderHeight = 22;
Pivot1->DefaultItemHeight = 20;
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"12[bold],0";
Expivotlib_tlb::IFormatConditionalAppearancePtr var_FormatConditionalAppearance = Pivot1->FormatConditionalAppearances->Add(L"nempty",TVariant("not empty"),TVariant(""));
var_FormatConditionalAppearance->Expression = L"len(value) != 0";
var_FormatConditionalAppearance->BackColor = RGB(240,240,240);
Pivot1->PivotColumns = L"sum(5)[nempty]/6";
Pivot1->IncludeExpandColumn = Expivotlib_tlb::IncludeExpandColumnEnum::exIncludeExpandColumn;
Pivot1->DrawGridLines = Expivotlib_tlb::GridLinesEnum::exNoLines;
Pivot1->EndUpdate();
|
|
86
|
How do I show expanded/collapsed columns
Pivot1->BeginUpdate();
Pivot1->HeaderHeight = 22;
Pivot1->DefaultItemHeight = 20;
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Expivotlib_tlb::IFormatConditionalAppearancePtr var_FormatConditionalAppearance = Pivot1->FormatConditionalAppearances->Add(L"nempty",TVariant("not empty"),TVariant(""));
var_FormatConditionalAppearance->Expression = L"len(value) != 0";
var_FormatConditionalAppearance->BackColor = RGB(240,240,240);
Pivot1->PivotColumns = L"sum(5)[nempty]/12";
Pivot1->FormatPivotHeader = L"(iaggregate ? ( caption + ` <r>[` + lower(caggregate) + `]` ) : caption)";
Pivot1->IncludeExpandColumn = Expivotlib_tlb::IncludeExpandColumnEnum::exIncludeExpandColumn;
Pivot1->EndUpdate();
|
|
85
|
Where you have say "Sum of ...." as the first row heading of the pivot are there and options to be able to change this text as a whole
Pivot1->BeginUpdate();
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Expivotlib_tlb::IFormatConditionalAppearancePtr var_FormatConditionalAppearance = Pivot1->FormatConditionalAppearances->Add(L"nempty",TVariant("not empty"),TVariant(""));
var_FormatConditionalAppearance->Expression = L"len(value) != 0";
var_FormatConditionalAppearance->BackColor = RGB(240,240,240);
Pivot1->PivotColumns = L"sum(5)[nempty]/12";
Pivot1->FormatPivotHeader = L"(iaggregate ? (`<b>` + caption + `</b> <off -6><font ;6>(` + lower(caggregate) + ' )') : caption)";
Pivot1->EndUpdate();
|
|
84
|
How can I get the data column from the cursor
// MouseMove event - Occurs when the user moves the mouse.
void __fastcall TForm1::Pivot1MouseMove(TObject *Sender,short Button,short Shift,int X,int Y)
{
OutputDebugString( L"DataColumn" );
OutputDebugString( PChar(Pivot1->DataColumnFromPoint[-1,-1]) );
}
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)[content=numeric]";
Pivot1->Refresh();
|
|
83
|
Is there any way for the user to change the alignment at runtime (using excontextmenu)
// RClick event - Occurs once the user right clicks the control.
void __fastcall TForm1::Pivot1RClick(TObject *Sender)
{
Expivotlib_tlb::AlignmentEnum h = Pivot1->DataColumns->get_item(TVariant(5))->Alignment;
/*
Select the Component\Import Component...\Import a Type Library,
to import the following Type Library:
ExContextMenu 1.0 Type Library
TypeLib: ExContextMenu.dll
to define the namespace: Excontextmenulib_tlb
*/
//#include "EXCONTEXTMENULIB_TLB.h"
Excontextmenulib_tlb::IExContextMenuPtr c = Variant::CreateObject(L"Exontrol.ContextMenu");
c->FlatImageWidth = 0;
c->ToString = TVariant(String("Alignment[align=1][dis],[group=0x71](Left[typ=2][grp=100][close=0][id=0],Center[typ=2][grp=100][close=0][id=1],Right[typ=2][grp") +
"=100][close=0][id=2])");
c->get_item(TVariant(h))->Checked = true;
h = c->Select(TNoParam(),TNoParam(),TNoParam());
Expivotlib_tlb::IColumnPtr var_Column = Pivot1->DataColumns->get_item(TVariant(5));
var_Column->Alignment = h;
var_Column->HeaderAlignment = h;
Pivot1->Refresh();
}
Pivot1->PivotBarVisible = Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowResizeColumns | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowUndoRedo | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAutoUpdate | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarShowTotals | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAutoFit | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarVisible;
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Expivotlib_tlb::IColumnPtr var_Column = Pivot1->DataColumns->get_item(TVariant(5));
var_Column->Alignment = Expivotlib_tlb::AlignmentEnum::RightAlignment;
var_Column->HeaderAlignment = Expivotlib_tlb::AlignmentEnum::RightAlignment;
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)[content=numeric]";
Pivot1->Refresh();
|
|
82
|
Is there any way for the user to change the alignment at runtime
// RClick event - Occurs once the user right clicks the control.
void __fastcall TForm1::Pivot1RClick(TObject *Sender)
{
OutputDebugString( L"The column gets aligned to the center" );
Expivotlib_tlb::IColumnPtr var_Column = Pivot1->DataColumns->get_item(TVariant(5));
var_Column->Alignment = Expivotlib_tlb::AlignmentEnum::CenterAlignment;
var_Column->HeaderAlignment = Expivotlib_tlb::AlignmentEnum::CenterAlignment;
Pivot1->Refresh();
}
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Expivotlib_tlb::IColumnPtr var_Column = Pivot1->DataColumns->get_item(TVariant(5));
var_Column->Alignment = Expivotlib_tlb::AlignmentEnum::RightAlignment;
var_Column->HeaderAlignment = Expivotlib_tlb::AlignmentEnum::RightAlignment;
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)[content=numeric]";
Pivot1->Refresh();
|
|
81
|
How can I align a column to the right
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Expivotlib_tlb::IColumnPtr var_Column = Pivot1->DataColumns->get_item(TVariant(5));
var_Column->Alignment = Expivotlib_tlb::AlignmentEnum::RightAlignment;
var_Column->HeaderAlignment = Expivotlib_tlb::AlignmentEnum::RightAlignment;
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)[content=numeric]";
Pivot1->Refresh();
|
|
80
|
How can I display the control's content on an single A3 paper size, when using PDF format
Pivot1->BeginUpdate();
Pivot1->VisualAppearance->Add(1,TVariant("c:\\exontrol\\images\\normal.ebn"));
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->FormatConditionalAppearances->get_item(TVariant("positive"))->BackColor = 0x100ff00;
Pivot1->FormatConditionalAppearances->get_item(TVariant("negative"))->BackColor = 0x10000ff;
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)[positive,negative]/12";
Pivot1->ExpandAll();
TVariant var_CopyTo = TVariant(Pivot1->CopyTo[L"C:\\Temp\\Preview.pdf|11.69 in x 16.53 in||single"]);
OutputDebugString( L"Look for C:\\Temp\\Preview.pd file." );
Pivot1->EndUpdate();
|
|
79
|
How can I display the control's content on an A3 paper size, when using PDF format
Pivot1->BeginUpdate();
Pivot1->VisualAppearance->Add(1,TVariant("c:\\exontrol\\images\\normal.ebn"));
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->FormatConditionalAppearances->get_item(TVariant("positive"))->BackColor = 0x100ff00;
Pivot1->FormatConditionalAppearances->get_item(TVariant("negative"))->BackColor = 0x10000ff;
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)[positive,negative]/12";
Pivot1->ExpandAll();
TVariant var_CopyTo = TVariant(Pivot1->CopyTo[L"C:\\Temp\\Preview.pdf|11.69 in x 16.53 in"]);
OutputDebugString( L"Look for C:\\Temp\\Preview.pd file." );
Pivot1->EndUpdate();
|
|
78
|
How can I export the control's content to a PDF document (method 1)
Pivot1->BeginUpdate();
Pivot1->VisualAppearance->Add(1,TVariant("c:\\exontrol\\images\\normal.ebn"));
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->FormatConditionalAppearances->get_item(TVariant("positive"))->BackColor = 0x100ff00;
Pivot1->FormatConditionalAppearances->get_item(TVariant("negative"))->BackColor = 0x10000ff;
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)[positive,negative]/12";
Pivot1->ExpandAll();
Pivot1->EndUpdate();
/*
Select the Component\Import Component...\Import a Type Library,
to import the following Type Library:
ExPrint 1.0 Control Library
TypeLib: ExPrint.dll
to define the namespace: Exprintlib_tlb
*/
//#include "EXPRINTLIB_TLB.h"
Exprintlib_tlb::IExPrintPtr var_Print = Variant::CreateObject(L"Exontrol.Print");
var_Print->PrintExt = (IUnknown*)Pivot1->DefaultDispatch;
var_Print->CopyTo(L"c:/temp/xtest.pdf");
OutputDebugString( L"Look for C:\\Temp\\xtest.pdf file." );
Pivot1->EndUpdate();
|
|
77
|
How can I export the control's content to a PDF document (method 2)
Pivot1->BeginUpdate();
Pivot1->VisualAppearance->Add(1,TVariant("c:\\exontrol\\images\\normal.ebn"));
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->FormatConditionalAppearances->get_item(TVariant("positive"))->BackColor = 0x100ff00;
Pivot1->FormatConditionalAppearances->get_item(TVariant("negative"))->BackColor = 0x10000ff;
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)[positive,negative]/12";
Pivot1->ExpandAll();
TVariant var_CopyTo = TVariant(Pivot1->CopyTo[L"c:/temp/xtest.pdf"]);
OutputDebugString( L"Look for C:\\Temp\\xtest.pdf file." );
Pivot1->EndUpdate();
|
|
76
|
Does / could the control have a read-only mode by where I could load the data and layout and just use the control to display it and allow the user to scroll around it / print it but not change it
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)[content=numeric]";
Pivot1->DisplayFilterList = Expivotlib_tlb::FilterListEnum::exNoItems;
Pivot1->PivotBarVisible = Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarReadOnly | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAutoUpdate | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAutoFit | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarVisible;
Pivot1->Refresh();
|
|
75
|
Is it possible to edit the conditional-expression at runtime
Pivot1->BeginUpdate();
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Expivotlib_tlb::IFormatConditionalAppearancePtr var_FormatConditionalAppearance = Pivot1->FormatConditionalAppearances->Add(L"custom",TVariant("custom"),TVariant(""));
var_FormatConditionalAppearance->Bold = true;
var_FormatConditionalAppearance->FontSize = 12;
var_FormatConditionalAppearance->Expression = L"value > 2000";
var_FormatConditionalAppearance->ContextEditExpression = true;
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)[custom]/12";
Pivot1->EndUpdate();
|
|
74
|
How can I highlight values using EBN colors
Pivot1->BeginUpdate();
Pivot1->VisualAppearance->Add(1,TVariant("c:\\exontrol\\images\\normal.ebn"));
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->FormatConditionalAppearances->get_item(TVariant("positive"))->BackColor = 0x100ff00;
Pivot1->FormatConditionalAppearances->get_item(TVariant("negative"))->BackColor = 0x10000ff;
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)[positive,negative]/12";
Pivot1->EndUpdate();
|
|
73
|
How do I mark not-empty values in the chart
Pivot1->BeginUpdate();
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Expivotlib_tlb::IFormatConditionalAppearancePtr var_FormatConditionalAppearance = Pivot1->FormatConditionalAppearances->Add(L"nempty",TVariant("not empty"),TVariant(""));
var_FormatConditionalAppearance->Expression = L"len(value) != 0";
var_FormatConditionalAppearance->BackColor = RGB(240,240,240);
Pivot1->PivotColumns = L"sum(5)[nempty]/12";
Pivot1->EndUpdate();
|
|
72
|
How can I highlight negative and positive values in the same chart
Pivot1->BeginUpdate();
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)[negative,positive]/12";
Pivot1->EndUpdate();
|
|
71
|
How can I highlight values that starts with a letter
Pivot1->BeginUpdate();
Expivotlib_tlb::IFormatConditionalAppearancePtr var_FormatConditionalAppearance = Pivot1->FormatConditionalAppearances->Add(L"f",TVariant("starts with f"),TVariant("lower(value) startwith `f`"));
var_FormatConditionalAppearance->Expression = L"lower(value) startwith `f`";
var_FormatConditionalAppearance->Shadow = RGB(1,0,0);
var_FormatConditionalAppearance->ShadowOffset = 0;
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0[f]";
Pivot1->EndUpdate();
|
|
70
|
How can I mark values greater than a value, 100 for instance
Pivot1->BeginUpdate();
Expivotlib_tlb::IFormatConditionalAppearancePtr var_FormatConditionalAppearance = Pivot1->FormatConditionalAppearances->Add(L"greater100",TVariant(">100"),TVariant("value > 100"));
var_FormatConditionalAppearance->Expression = L"( dbl(value) != 0 ) ? (value > 100) : 0";
var_FormatConditionalAppearance->ForeColor = RGB(255,0,0);
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)[greater100,content=numeric]";
Pivot1->EndUpdate();
|
|
69
|
How can I remove the Conditional context-menu
Pivot1->BeginUpdate();
Pivot1->PivotBarVisible = Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowResizeColumns | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowUndoRedo | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAutoUpdate | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowFormatContent | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowFormatAppearance | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowValues | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarShowTotals | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAutoFit | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarSizable | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarVisible;
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)[content=numeric]";
Pivot1->EndUpdate();
|
|
68
|
How do change the way the negative/positive numbers show when using conditional-format
Pivot1->BeginUpdate();
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Expivotlib_tlb::IFormatConditionalAppearancePtr var_FormatConditionalAppearance = Pivot1->FormatConditionalAppearances->get_item(TVariant("negative"));
var_FormatConditionalAppearance->BackColor = RGB(0,0,0);
var_FormatConditionalAppearance->ForeColor = RGB(128,128,128);
var_FormatConditionalAppearance->FontSize = 8;
Expivotlib_tlb::IFormatConditionalAppearancePtr var_FormatConditionalAppearance1 = Pivot1->FormatConditionalAppearances->get_item(TVariant("positive"));
var_FormatConditionalAppearance1->BackColor = RGB(0,0,0);
var_FormatConditionalAppearance1->ForeColor = RGB(1,0,0);
var_FormatConditionalAppearance1->FontSize = 11;
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)[negative,positive,content=numeric]";
Pivot1->EndUpdate();
|
|
67
|
How do I highlight the negative values with white color or black
Pivot1->BeginUpdate();
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Expivotlib_tlb::IFormatConditionalAppearancePtr var_FormatConditionalAppearance = Pivot1->FormatConditionalAppearances->get_item(TVariant("negative"));
var_FormatConditionalAppearance->BackColor = RGB(1,0,0);
var_FormatConditionalAppearance->ForeColor = RGB(255,255,255);
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)[negative,content=numeric]";
Pivot1->EndUpdate();
|
|
66
|
Does your control support conditional-format, so I can highlight certain values
Pivot1->BeginUpdate();
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)[negative,content=numeric]";
Pivot1->EndUpdate();
|
|
65
|
How do I add a computed column/field, like VAT for instance (method 2)
Pivot1->BeginUpdate();
Expivotlib_tlb::IAggregatesPtr var_Aggregates = Pivot1->Aggregates;
var_Aggregates->Add(L"vat19",TVariant("sum"),TVariant("VAT 19%"),TVariant("VAT 19%"))->FormatValue = L"value * 0.19";
var_Aggregates->Add(L"vat24",TVariant("sum"),TVariant("VAT 24%"),TVariant("VAT 24%"))->FormatValue = L"value * 0.24";
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)[content=numeric],vat19(5)[bold,content=numeric],vat24(5)[bold,content=numeric]";
Pivot1->EndUpdate();
|
|
64
|
How do I add a computed column/field, like VAT for instance (method 1)
Pivot1->BeginUpdate();
Expivotlib_tlb::IFormatContentPtr var_FormatContent = Pivot1->FormatContents->Add(L"vat19",L"VAT 19%",TNoParam());
var_FormatContent->Expression = L"len(value) ? ((value * 1.19) format '') : ''";
Expivotlib_tlb::IFormatContentPtr var_FormatContent1 = Pivot1->FormatContents->Add(L"vat24",L"VAT 24%",TNoParam());
var_FormatContent1->Expression = L"len(value) ? ((value * 1.24) format '') : ''";
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)[content=numeric],sum(5)[bold,content=vat19],sum(5)[bold,content=vat24]";
Pivot1->EndUpdate();
|
|
63
|
How can I hide some values for instance negative values
Pivot1->BeginUpdate();
Expivotlib_tlb::IFormatContentPtr var_FormatContent = Pivot1->FormatContents->Add(L"hiden",L"hide negative",TNoParam());
var_FormatContent->Expression = L"value < 0 ? `` : value";
Expivotlib_tlb::IFormatContentPtr var_FormatContent1 = Pivot1->FormatContents->Add(L"hidep",L"hide positive",TNoParam());
var_FormatContent1->Expression = L"value > 0 ? `` : value";
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)[bold],sum(5)[content=hiden],sum(5)[content=hidep]";
Pivot1->EndUpdate();
|
|
62
|
How can I decode the Layout property
Pivot1->BeginUpdate();
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)/12";
Pivot1->Layout = L"Columns =1;C0.Width = 64";
/*
Select the Component\Import Component...\Import a Type Library,
to import the following Type Library:
ExPrint 1.0 Control Library
TypeLib: ExPrint.dll
to define the namespace: Exprintlib_tlb
*/
//#include "EXPRINTLIB_TLB.h"
Exprintlib_tlb::IExPrintPtr var_Print = Variant::CreateObject(L"Exontrol.Print");
OutputDebugString( var_Print->get_Decode64TextW(Pivot1->Layout) );
Pivot1->EndUpdate();
|
|
61
|
How can I specify the sorting type, so the column gets sorted as numeric for instance
Pivot1->Import(TVariant("1,1#11,11#101,101"),TVariant("eor='#' eof=',' hdr=0"));
Expivotlib_tlb::IColumnPtr var_Column = Pivot1->DataColumns->get_item(TVariant(0));
var_Column->Caption = L"Numeric";
var_Column->SortType = Expivotlib_tlb::SortTypeEnum::SortNumeric;
Pivot1->DataColumns->get_item(TVariant(1))->Caption = L"String (default)";
Pivot1->PivotRows = L"0";
Pivot1->Refresh();
|
|
60
|
How can I disable the control's context menu
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Pivot1->PivotBarVisible = Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowResizeColumns | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowUndoRedo | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAutoUpdate | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowValues | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarShowTotals | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAutoFit | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarSizable | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarVisible;
|
|
59
|
How do I get the captions of the columns
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
OutputDebugString( PChar(Pivot1->DataColumns->Count) );
OutputDebugString( Pivot1->DataColumns->get_item(TVariant(0))->PivotCaption );
OutputDebugString( Pivot1->DataColumns->get_item(TVariant(0))->Caption );
OutputDebugString( Pivot1->DataColumns->get_item(TVariant(1))->PivotCaption );
OutputDebugString( Pivot1->DataColumns->get_item(TVariant(1))->Caption );
|
|
58
|
How can I specify the default-format for a specified column, so it always shows as numeric for instance
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Expivotlib_tlb::IColumnPtr var_Column = Pivot1->DataColumns->get_item(TVariant("Freight"));
var_Column->DefaultFormatContent = L"numeric";
var_Column->DefaultFormatAppearances = L"bold";
var_Column->SortOrder = Expivotlib_tlb::SortOrderEnum::SortAscending;
var_Column->SortType = Expivotlib_tlb::SortTypeEnum::SortNumeric;
Pivot1->PivotTotalDefaultFormatContent = L"currency";
Pivot1->PivotTotalDefaultFormatAppearances = L"strikeout,bold";
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)[bold,content=numeric]";
Pivot1->PivotTotals = L"sum[strikeout,bold,content=currency]";
Pivot1->PivotColumnsFloatBarVisible = Expivotlib_tlb::PanelVisibleEnum::exPanelVisible;
Pivot1->Refresh();
|
|
57
|
How can I display the percentage column
Pivot1->FormatContents->Add(L"percent",L"value + `%`",TNoParam());
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"5[content=percent]";
Pivot1->Refresh();
|
|
56
|
How do I change the name for months in the drop-down filter window (localization)
OutputDebugString( Pivot1->Description[Expivotlib_tlb::DescriptionTypeEnum::exFilterBarDateMonths] );
Pivot1->Description[Expivotlib_tlb::DescriptionTypeEnum::exFilterBarDateMonths] = L"Ianuarie Februarie Martie Aprilie Mai Iunie Iulie August Septembrie Octombrie Noiembrie Decembrie";
Pivot1->Description[Expivotlib_tlb::DescriptionTypeEnum::exFilterBarAll] = L"(Toate)";
Pivot1->Description[Expivotlib_tlb::DescriptionTypeEnum::exFilterBarBlanks] = L"(Gol)";
Pivot1->Description[Expivotlib_tlb::DescriptionTypeEnum::exFilterBarNonBlanks] = L"(Plin)";
Pivot1->Description[Expivotlib_tlb::DescriptionTypeEnum::exFilterBarFilterForCaption] = L"Filtreaza:";
Pivot1->Description[Expivotlib_tlb::DescriptionTypeEnum::exFilterBarDateTodayCaption] = L"Azi";
Pivot1->Description[Expivotlib_tlb::DescriptionTypeEnum::exFilterBarDateWeekDays] = L"D L Ma Mi J V S";
Pivot1->Description[Expivotlib_tlb::DescriptionTypeEnum::exFilterBarExclude] = L"Exclud";
Pivot1->Description[Expivotlib_tlb::DescriptionTypeEnum::exColumnsFloatBar] = L"Coloane";
Pivot1->Description[Expivotlib_tlb::DescriptionTypeEnum::exFilterBarAnd] = L"si";
Pivot1->Description[Expivotlib_tlb::DescriptionTypeEnum::exFilterBarDate] = L"Data:";
Pivot1->Description[Expivotlib_tlb::DescriptionTypeEnum::exFilterBarDateTitle] = L"Data";
Pivot1->Description[Expivotlib_tlb::DescriptionTypeEnum::exFilterBarDateTo] = L"la";
Pivot1->Description[Expivotlib_tlb::DescriptionTypeEnum::exFilterBarNot] = L"nu";
Pivot1->Description[Expivotlib_tlb::DescriptionTypeEnum::exFilterBarOr] = L"sau";
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->DataColumns->get_item(TVariant("OrderDate"))->SortType = Expivotlib_tlb::SortTypeEnum::SortDate;
Pivot1->PivotRows = L"9";
Pivot1->Refresh();
|
|
55
|
How can I scale and print programmatically the pivot table, to fit on one axis eg FitPageHeight but infinite width etc
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"6";
Pivot1->PivotColumns = L"sum(5)/3";
Pivot1->Refresh();
/*
Select the Component\Import Component...\Import a Type Library,
to import the following Type Library:
ExPrint 1.0 Control Library
TypeLib: ExPrint.dll
to define the namespace: Exprintlib_tlb
*/
//#include "EXPRINTLIB_TLB.h"
Exprintlib_tlb::IExPrintPtr var_Print = Variant::CreateObject(L"Exontrol.Print");
var_Print->set_Options(TVariant("FitToPage = x 5"));
var_Print->set_PrintExts(Pivot1->DefaultDispatch);
var_Print->Preview();
|
|
54
|
How can I scale and print programmatically the pivot table, to fit on one axis eg FitPageWidth but infinite height etc
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"6";
Pivot1->PivotColumns = L"sum(5)/3";
Pivot1->Refresh();
/*
Select the Component\Import Component...\Import a Type Library,
to import the following Type Library:
ExPrint 1.0 Control Library
TypeLib: ExPrint.dll
to define the namespace: Exprintlib_tlb
*/
//#include "EXPRINTLIB_TLB.h"
Exprintlib_tlb::IExPrintPtr var_Print = Variant::CreateObject(L"Exontrol.Print");
var_Print->set_Options(TVariant("FitToPage = 5 x"));
var_Print->set_PrintExts(Pivot1->DefaultDispatch);
var_Print->Preview();
|
|
53
|
How can I get the column from the cursor
// MouseMove event - Occurs when the user moves the mouse.
void __fastcall TForm1::Pivot1MouseMove(TObject *Sender,short Button,short Shift,int X,int Y)
{
OutputDebugString( PChar(Pivot1->ColumnFromPoint[-1,-1]) );
}
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->Refresh();
|
|
52
|
How can I get the value from the cursor
// MouseMove event - Occurs when the user moves the mouse.
void __fastcall TForm1::Pivot1MouseMove(TObject *Sender,short Button,short Shift,int X,int Y)
{
OutputDebugString( PChar(Pivot1->ValueFromPoint[-1,-1]) );
}
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->Refresh();
|
|
51
|
How can I specify a column to display HTML format
Pivot1->Import(TVariant("Bold <b>1,Bold <b>2#Bold <b>3,Bold <b>4#Bold <b>5,Bold <b>6"),TVariant("eor='#' eof=',' hdr=0"));
Pivot1->DataColumns->get_item(TVariant(0))->HTML = true;
Pivot1->DataColumns->get_item(TVariant(1))->HTML = true;
Pivot1->PivotRows = L"0";
Pivot1->Refresh();
|
|
50
|
Does your control supports scrolling by touching the screen
/*
Select the Component\Import Component...\Import a Type Library,
to import the following Type Library:
Microsoft ActiveX Data Objects 6.1 Library
TypeLib: msado15.dll
to define the namespace: Adodb_tlb
*/
//#include "ADODB_TLB.h"
Adodb_tlb::_RecordsetPtr rs = Variant::CreateObject(L"ADOR.Recordset");
rs->Open(TVariant("Data"),TVariant("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Program Files\\Exontrol\\ExPivot\\Sample\\Access\\sample.accdb"),Adodb_tlb::CursorTypeEnum::adOpenStatic,Adodb_tlb::LockTypeEnum::adLockOptimistic,0);
Pivot1->DataSource = (IDispatch*)rs;
Pivot1->AutoDrag = Expivotlib_tlb::AutoDragEnum::exAutoDragScrollOnShortTouch | Expivotlib_tlb::AutoDragEnum::exAutoDragScroll;
|
|
49
|
How can I specify programatically the width of the pivot column ( first column )
Pivot1->BeginUpdate();
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)/12";
Pivot1->Layout = L"Columns =1;C0.Width = 64";
Pivot1->EndUpdate();
|
|
48
|
How can I show the total of each row, when columns are shown as expanded
Pivot1->BeginUpdate();
Pivot1->IncludeExpandColumn = Expivotlib_tlb::IncludeExpandColumnEnum::exIncludeExpandColumn;
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)/12";
Pivot1->EndUpdate();
|
|
47
|
How can I prevent grouping by a specified column
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->DataColumns->get_item(TVariant("Freight"))->AllowGroupBy = Expivotlib_tlb::AllowGroupByEnum::exGroupByNone;
|
|
46
|
How can I sort alphabetically the columns to be displayed in the context menu/floating panel
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotBarVisible = Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarContextSortAscending | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowResizeColumns | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowUndoRedo | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAutoUpdate | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowFormatContent | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowFormatAppearance | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowValues | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarShowTotals | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAutoFit | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarSizable | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarVisible;
Pivot1->PivotColumnsSortOrder = Expivotlib_tlb::PivotColumnsSortOrderEnum::exPivotColumnsAscending;
Pivot1->PivotColumnsFloatBarVisible = Expivotlib_tlb::PanelVisibleEnum::exPanelVisible;
|
|
45
|
How can I prevent dropping data to the control
Pivot1->AllowDrop = false;
|
|
44
|
Is it possible to allow incremental filtering on drop down filter window too, as I can on the control menus
Expivotlib_tlb::FilterListEnum var_DisplayFilterList = Pivot1->DisplayFilterList;
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Pivot1->DisplayFilterList = Expivotlib_tlb::FilterListEnum::exHideFilterPattern | Expivotlib_tlb::FilterListEnum::exFilterListDefault;
|
|
43
|
How can I prevent showing the Filter For field in the drop down filter window
Expivotlib_tlb::FilterListEnum var_DisplayFilterList = Pivot1->DisplayFilterList;
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Pivot1->DisplayFilterList = Expivotlib_tlb::FilterListEnum::exHideFilterPattern | Expivotlib_tlb::FilterListEnum::exFilterListDefault;
|
|
42
|
How can I display the numeric columns only when selecting a new aggregate, like SUM
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0[bold]";
Pivot1->PivotColumns = L"sum(5)/12,count(5)/12";
Pivot1->DataColumns->get_item(TVariant("Freight"))->SortType = Expivotlib_tlb::SortTypeEnum::SortNumeric;
|
|
41
|
How can I add a value column
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)/12";
|
|
40
|
I would like to always have the subtotals in the same row of the "father row". Could that be done
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0[bold],2";
Pivot1->PivotColumns = L"sum(5)/12,count(5)/12";
Pivot1->ShowViewCompact = Expivotlib_tlb::ShowViewCompactEnum::exViewCompactAggregates | Expivotlib_tlb::ShowViewCompactEnum::exViewCompact;
Pivot1->PivotTotals = L"/sum,sum(0)";
|
|
39
|
Is there any way, when I change the filter of the column, it broadcast the filter to the other pivot columns that were duplicated
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0,2";
Pivot1->ShowBranchRows = Expivotlib_tlb::ShowBranchRowsEnum::exBranchCompact;
Pivot1->PivotColumns = TVariant(String("sum(5)/12[filter='gBpNxjNh1MhlBoKNhpOZ0hJVNxpOhlMggKBhMZrMJnMoAgI='],count(5)/12[filter='gBpNxjNh1MhlBoKNhpOZ0hJVNxpOhlMggKBhMZ") +
"rMJnMoAgI=']");
Pivot1->ShowViewCompact = Expivotlib_tlb::ShowViewCompactEnum::exViewCompactKeepSettings | Expivotlib_tlb::ShowViewCompactEnum::exViewCompact;
|
|
38
|
How can I summarize more fields in the same cell
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0,2";
Pivot1->ShowBranchRows = Expivotlib_tlb::ShowBranchRowsEnum::exBranchCompact;
Pivot1->PivotColumns = L"sum(5)/12,count(5)/12";
Pivot1->ShowViewCompact = Expivotlib_tlb::ShowViewCompactEnum::exViewCompact;
|
|
37
|
How do I programmatically group by rows, in a compact way, no hierarchy lines
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0,2";
Pivot1->ShowBranchRows = Expivotlib_tlb::ShowBranchRowsEnum::exBranchCompact;
|
|
36
|
How do I programmatically group by rows
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0,1,2";
Pivot1->LinesAtRoot = Expivotlib_tlb::LinesAtRootEnum::exLinesAtRoot;
Pivot1->HasLines = Expivotlib_tlb::HierarchyLineEnum::exSolidLine;
|
|
35
|
How do I programmatically group by columns
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)/12;6";
|
|
34
|
How can I hide the add new button on the pivot bar
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotBarVisible = Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarHideAddNew | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowResizeColumns | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowUndoRedo | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAutoUpdate | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowFormatContent | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowFormatAppearance | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowValues | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarShowTotals | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAutoFit | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarSizable | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarVisible;
|
|
33
|
Is it possible to show the data that generated the result, when double clicking the row
Pivot1->BeginUpdate();
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0[italic]";
Pivot1->PivotColumns = L"count(0)[underline]";
Pivot1->PivotTotals = L"count[bold,strikeout]";
Pivot1->ShowDataOnDblClick = true;
Pivot1->EndUpdate();
|
|
32
|
Does your control support subscript or superscript, in HTML captions
Pivot1->HeaderHeight = 22;
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->DataColumns->get_item(TVariant("ShipCountry"))->Caption = L"ShipCountry<font ;7><off 6><sha ;;0>subscript";
Pivot1->DataColumns->get_item(TVariant("ShipRegion"))->Caption = L"ShipRegion<font ;7><off -6><sha ;;0>superscript";
Pivot1->Refresh();
|
|
31
|
Is it possible to define a different background color for the pivot bar
Pivot1->Background[Expivotlib_tlb::BackgroundPartEnum::exPivotBarBackColor] = RGB(240,240,240);
|
|
30
|
How can I display an icon/image to Content sub-menu
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->Images(TVariant(String("gBJJgBAIDAAGAAEAAQhYAf8Pf4hh0QihCJo2AEZjQAjEZFEaIEaEEaAIAkcbk0olUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq") +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9v1/wGBwWDwmFw2HxGJxWLxmNx0xiFdyOTh8Tf9ZymXx+QytcyNgz8r0OblWjyWds+m" +
"0ka1Vf1ta1+r1mos2xrG2xeZ0+a0W0qOx3GO4NV3WeyvD2XJ5XL5nN51aiw+lfSj0gkUkAEllHanHI5j/cHg8EZf7w8vl8j4f/qfEZeB09/vjLAB30+kZQAP/P5/H6/y" +
"NAOAEAwCjMBwFAEDwJBMDwLBYAP2/8Hv8/gAGAD8LQs9w/nhDY/oygIA="));
Pivot1->FormatContents->get_item(TVariant("numeric"))->Name = L"<img>1</img> Numeric";
Pivot1->PivotRows = L"5[content=numeric]";
|
|
29
|
How can I change the selection background in the control's context menu
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->Background[Expivotlib_tlb::BackgroundPartEnum::exSelBackColorFilter] = RGB(255,0,0);
|
|
28
|
How can I display the column as date in a long format
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->FormatContents->Add(L"longdate",L"longdate(date(value))",TNoParam());
Pivot1->PivotRows = L"9[content=longdate]";
|
|
27
|
Is it possible to display the column in upper-case
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->FormatContents->Add(L"upper",L"upper(value)",TNoParam());
Pivot1->PivotRows = L"0[content=upper]";
|
|
26
|
How can I programatically bold a column
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0[bold]";
|
|
25
|
How can I display the total with a different foreground color
Pivot1->FormatAppearances->Add(L"fore",TNoParam())->ForeColor = RGB(255,0,0);
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)";
Pivot1->PivotTotals = L"sum[fore,bold]";
|
|
24
|
How can I display the total with a different background color/ebn
Pivot1->VisualAppearance->Add(1,TVariant("c:\\exontrol\\images\\normal.ebn"));
Pivot1->FormatAppearances->Add(L"back",TNoParam())->BackColor = 0x1000000;
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)";
Pivot1->PivotTotals = L"sum[back]";
|
|
23
|
How can I display the total with a solid background color
Pivot1->FormatAppearances->Add(L"back",TNoParam())->BackColor = RGB(240,240,240);
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)";
Pivot1->PivotTotals = L"sum[back]";
|
|
22
|
Is it possible to change the "bold" caption in the control's context menu
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->FormatAppearances->get_item(TVariant("bold"))->Name = L"Ingrosat";
|
|
21
|
Is it possible to show no Exclude field in the filter window
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->DisplayFilterList = Expivotlib_tlb::FilterListEnum::exShowCheckBox | Expivotlib_tlb::FilterListEnum::exSortItemsAsc;
|
|
20
|
How can I prevent showing the drop down filter button
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->DisplayFilterList = Expivotlib_tlb::FilterListEnum::exNoItems;
|
|
19
|
How do I get the count of positive values only
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->Aggregates->Add(L"positive",TVariant("sum"),TNoParam(),TNoParam())->FormatValue = L"value < 0 ? 0 : 1";
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"positive(5)";
|
|
18
|
How do I get the sum for negative values only
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->Aggregates->Add(L"negative",TVariant("sum"),TNoParam(),TNoParam())->FormatValue = L"value < 0 ? value : 0";
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"negative(5)";
|
|
17
|
My data stores the data as strings, is it possible to load the data using Import method
Pivot1->Import(TVariant("'string 1';'string 2'#'string 3';'string 4'"),TVariant("str=`'` eor='#' eof=';' hdr=0"));
|
|
16
|
Is it possible to load data using different separators
Pivot1->Import(TVariant("item 1;item 2#item 3;item 4"),TVariant("eor='#' eof=';' hdr=0"));
|
|
15
|
Is it possible to align a column
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Expivotlib_tlb::IColumnPtr var_Column = Pivot1->DataColumns->get_item(TVariant(0));
var_Column->Alignment = Expivotlib_tlb::AlignmentEnum::RightAlignment;
var_Column->HeaderAlignment = Expivotlib_tlb::AlignmentEnum::RightAlignment;
Pivot1->Refresh();
|
|
14
|
How can I change by code the column/rows background color
Pivot1->BeginUpdate();
Pivot1->VisualAppearance->Add(1,TVariant("c:\\exontrol\\images\\normal.ebn"));
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->FormatAppearances->Add(L"aka",TNoParam())->BackColor = 0x1000000;
Pivot1->PivotRows = L"0[aka]";
Pivot1->EndUpdate();
|
|
13
|
How can I apply by code any appearance to my list
Pivot1->BeginUpdate();
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0[italic]";
Pivot1->PivotColumns = L"count(0)[underline]";
Pivot1->PivotTotals = L"count[bold,strikeout]";
Pivot1->EndUpdate();
|
|
12
|
How can I display an icon instead SUM/Total field
Pivot1->BeginUpdate();
Pivot1->Images(TVariant(String("gBJJgBggAAwAAgACEKAD/hz/EMNh8TIRNGwAjEZAEXjAojJAjIgjIBAEijUlk8plUrlktl0vmExmUzmk1m03nE5nU7nk9n0/oFBoVDolFo1HpFJpVLplNp1PqFRqVTq") +
"lVq1XrFZrVbrldr1fsFhsVjslls1ntFptVrtltt1vuFxuVzul1u13vF5vV7vl9oEEwGBwWDwmFw2Hw9+xUsxGNx2Px+LyUnyGVy2VyeZAGNjIJjITjIb0OjjGi0ukAAV" +
"jILzmayWtAGejCvjLh2u3jG23O4ACx1ew11+zEYGsZZsZUe/wkZ4sYZvD4PCy8kjAzjLFjKd5WDjIz6HRvnTwUZGMZX8ZTPb8XU8Hh9cFjALjKVjK5jIv9/w9t78WdjJ" +
"IoyWr7sKjIWu+/a8Og2QAEajLaIxAzlwhB0DwQuzoECjJWw1DiMQ3D0OgAQMKwsuj8xOy0SrzFEWMdFUExbGMCRfC8ZRswMaLsiofJVHiOo+kKRs2lL2Jsh8cyQo6Ag=" +
"="));
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Expivotlib_tlb::IAggregatePtr var_Aggregate = Pivot1->Aggregates->get_item(TVariant("sum"));
var_Aggregate->Name = L"<img>1</img> Sum";
var_Aggregate->Caption = L"<img>1</img>";
Pivot1->PivotColumnsFloatBarVisible = Expivotlib_tlb::PanelVisibleEnum::exPanelVisible;
Pivot1->FormatPivotHeader = L"iaggregate ? (caggregate + (iaggregate != 5 ? ' ' : '') + caption) : caption";
Pivot1->FormatPivotTotal = L"caggregate";
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)";
Pivot1->PivotTotals = L"sum,count";
Pivot1->EndUpdate();
|
|
11
|
How can I change the caption to be displayed when dragging an aggregate function
Pivot1->BeginUpdate();
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotColumnsFloatBarVisible = Expivotlib_tlb::PanelVisibleEnum::exPanelVisible;
Pivot1->FormatPivotHeader = L"(iaggregate ? ('<b>' + upper(caggregate) + '</b> of ' + caption) : caption)";
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)";
Pivot1->PivotTotals = L"sum,count";
Pivot1->EndUpdate();
|
|
10
|
I am using Import method, just wondering if I can rename the columns
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Expivotlib_tlb::IColumnPtr var_Column = Pivot1->DataColumns->get_item(TVariant(0));
var_Column->Caption = L"New Caption";
var_Column->PivotCaption = L"New Pivot Caption";
Pivot1->Refresh();
|
|
9
|
Does your control support Fit-To-Page Print and Print Preview
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0,1,2";
Pivot1->ExpandAll();
/*
Select the Component\Import Component...\Import a Type Library,
to import the following Type Library:
ExPrint 1.0 Control Library
TypeLib: ExPrint.dll
to define the namespace: Exprintlib_tlb
*/
//#include "EXPRINTLIB_TLB.h"
Exprintlib_tlb::IExPrintPtr var_Print = Variant::CreateObject(L"Exontrol.Print");
var_Print->set_Options(TVariant("FitToPage = On"));
var_Print->set_PrintExts(Pivot1->DefaultDispatch);
var_Print->Preview();
|
|
8
|
How can I print the control
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0,1,2";
Pivot1->ExpandAll();
/*
Select the Component\Import Component...\Import a Type Library,
to import the following Type Library:
ExPrint 1.0 Control Library
TypeLib: ExPrint.dll
to define the namespace: Exprintlib_tlb
*/
//#include "EXPRINTLIB_TLB.h"
Exprintlib_tlb::IExPrintPtr var_Print = Variant::CreateObject(L"Exontrol.Print");
var_Print->set_PrintExts(Pivot1->DefaultDispatch);
var_Print->Preview();
|
|
7
|
How can I hide the pivot bar (hide completly)
Pivot1->PivotBarVisible = Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowResizeColumns | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowUndoRedo | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAutoUpdate | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowFormatContent | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowFormatAppearance | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowValues | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarShowTotals | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAutoFit | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarSizable;
|
|
6
|
How can I hide the pivot bar (auto-hide)
Pivot1->PivotBarVisible = Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowResizeColumns | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowUndoRedo | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAutoUpdate | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowFormatContent | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowFormatAppearance | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAllowValues | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarAutoHide | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarShowTotals | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarSizable | Expivotlib_tlb::PivotBarVisibleEnum::exPivotBarVisible;
|
|
5
|
How can I count and get the total of a specified column
Pivot1->BeginUpdate();
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotColumnsFloatBarVisible = Expivotlib_tlb::PanelVisibleEnum::exPanelVisible;
Pivot1->PivotRows = L"0";
Pivot1->PivotColumns = L"sum(5)";
Pivot1->PivotTotals = L"sum,count";
Pivot1->EndUpdate();
|
|
4
|
How can I add show the columns once I grouped a column
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0";
Pivot1->PivotColumnsFloatBarVisible = Expivotlib_tlb::PanelVisibleEnum::exPanelVisible;
|
|
3
|
How can I programatically group the columns
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
Pivot1->PivotRows = L"0:D";
|
|
2
|
Is it possible to load data from a data source
/*
Select the Component\Import Component...\Import a Type Library,
to import the following Type Library:
Microsoft ActiveX Data Objects 6.1 Library
TypeLib: msado15.dll
to define the namespace: Adodb_tlb
*/
//#include "ADODB_TLB.h"
Adodb_tlb::_RecordsetPtr rs = Variant::CreateObject(L"ADOR.Recordset");
rs->Open(TVariant("Data"),TVariant("Provider=Microsoft.ACE.OLEDB.12.0;Data Source=C:\\Program Files\\Exontrol\\ExPivot\\Sample\\Access\\sample.accdb"),Adodb_tlb::CursorTypeEnum::adOpenStatic,Adodb_tlb::LockTypeEnum::adLockOptimistic,0);
Pivot1->DataSource = (IDispatch*)rs;
|
|
1
|
How can I load data
Pivot1->Import(TVariant("C:\\Program Files\\Exontrol\\ExPivot\\Sample\\data.txt"),TNoParam());
|